CREATE PROCEDURE [dbo].[BAEImisProductGetAllBilling]
AS
    SELECT p.[PRODUCT_CODE], p.[PRODUCT_MAJOR], p.[PRODUCT_MINOR], p.[PROD_TYPE], p.[CATEGORY], p.[TITLE_KEY], p.[TITLE],
           p.[DESCRIPTION], p.[STATUS], p.[NOTE], p.[GROUP_1], p.[GROUP_2], p.[GROUP_3], p.[PRICE_RULES_EXIST], p.[LOT_SERIAL_EXIST],
           p.[PAYMENT_PRIORITY], p.[RENEW_MONTHS], p.[PRORATE], p.[STOCK_ITEM], p.[UNIT_OF_MEASURE], p.[WEIGHT], p.[TAXABLE],
           p.[COMMISIONABLE], p.[COMMISION_PERCENT], p.[DECIMAL_POINTS], p.[INCOME_ACCOUNT], p.[DEFERRED_INCOME_ACCOUNT],
           p.[INVENTORY_ACCOUNT], p.[ADJUSTMENT_ACCOUNT], p.[COG_ACCOUNT], p.[INTENT_TO_EDIT], p.[PRICE_1], p.[PRICE_2], p.[PRICE_3],
           p.[COMPLIMENTARY], p.[ATTRIBUTES], p.[PST_TAXABLE], p.[TAXABLE_VALUE], p.[ORG_CODE], p.[TAX_AUTHORITY], p.[WEB_OPTION],
           p.[IMAGE_URL], p.[APPLY_IMAGE], p.[IS_KIT], p.[INFO_URL], p.[APPLY_INFO], p.[PLP_CODE], p.[PROMOTE], p.[THUMBNAIL_URL],
           p.[APPLY_THUMBNAIL], p.[CATALOG_DESC], p.[WEB_DESC], p.[OTHER_DESC], p.[LOCATION], p.[PREMIUM], p.[FAIR_MARKET_VALUE],
           p.[IS_FR_ITEM], p.[APPEAL_CODE], p.[CAMPAIGN_CODE], p.[TIME_STAMP], p.[ProductKey]
      FROM [dbo].[Product] p
     WHERE p.[PROD_TYPE] IN ('DUES', 'MISC', 'CHAPT', 'SEC', 'SUB', 'VOL')


GO